UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XiFJdSc4r8gvcf7K7OmIaz2urmm8hZ/ZrHmS6LGvyB4='
WHERE
key_id = '77d276d48f2d2a61ed4306fda6e1abe11945b2d0d3cfbeb2777d777793cd24ef'
AND (
token = 'XiFJdSc4r8gvcf7K7OmIaz2urmm8hZ/ZrHmS6LGvyB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)