UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QZtk6xLRCjgxOiLELzIurS9ZZddsva6kiP0FPyPGH0k='
WHERE
key_id = '4a3bcbae0e73aebdc7b7017380cb58c5188dc7222febf35a6289f42e718fa711'
AND (
token = 'QZtk6xLRCjgxOiLELzIurS9ZZddsva6kiP0FPyPGH0k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)