UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RDfWvI5H7caHi8v35pFJF46fQpN4sGNOf0XD5b/nfdU='
WHERE
key_id = 'ad6bd0bf503bf44d9281ad874a05756026ff5ad10e75eae6f03cd30907406821'
AND (
token = 'RDfWvI5H7caHi8v35pFJF46fQpN4sGNOf0XD5b/nfdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)