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