UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K2DPrm4fF2Aecl7ruzwSQnro/uSGftkOACX5Fmz4vlY='
WHERE
key_id = 'a92a40a4b00ddd9a79478235f339446994ad429979b266353905a17a5a51b39e'
AND (
token = 'K2DPrm4fF2Aecl7ruzwSQnro/uSGftkOACX5Fmz4vlY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)