UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZEQeAKQcmI12DEHWRZTD8diNRF6YhmBQzcRThQwcg1o='
WHERE
key_id = 'c6c58c64eba5f8df207628f8d304a51f877eb45a04b68f647c79412ae08e3294'
AND (
token = 'ZEQeAKQcmI12DEHWRZTD8diNRF6YhmBQzcRThQwcg1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)