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