UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qclL05uLnqYlWZAJrTa8tnFvCkZ0O/LKwbuUODeOU0w='
WHERE
key_id = '7dc24a6337b24ff675585021f3df8fbae3eea6cdd218c75d23c99ca8c92b1e3d'
AND (
token = 'qclL05uLnqYlWZAJrTa8tnFvCkZ0O/LKwbuUODeOU0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)