UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h9iw9IBOFJthqG0uBSBflmDqS4S9HoNM2px5JjGCC2g='
WHERE
key_id = '842208ada479aa87425ce736eedc8716e72e2f6ebbcfa5c897ab019b0b43f0b3'
AND (
token = 'h9iw9IBOFJthqG0uBSBflmDqS4S9HoNM2px5JjGCC2g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)