UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SdqRGoTfLf3HZvcfVF0Y0xeT9W+EGsVgshDzW0eRSgc='
WHERE
key_id = 'dac227eeec89254290feeac76a0810798539ad077a6f8e5df5a0d51e333aeed1'
AND (
token = 'SdqRGoTfLf3HZvcfVF0Y0xeT9W+EGsVgshDzW0eRSgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)