UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1wt6+ZwDRRiyhpeWwzDF/j56CRLERi85kXbKHec72kg='
WHERE
key_id = '3a12187adc8f9f91c42687f566ac0bae4a00bf03bb7bf92f9cfa905ac497842a'
AND (
token = '1wt6+ZwDRRiyhpeWwzDF/j56CRLERi85kXbKHec72kg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)