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