UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HAn+cL0wv0hYf8IMguWzh3GWVDZ68YTSwLhhe0pTM6A='
WHERE
key_id = 'e36153e961d29f7eeefd256af4018be1a67f530fc69717dc72cfc003ffaa2a09'
AND (
token = 'HAn+cL0wv0hYf8IMguWzh3GWVDZ68YTSwLhhe0pTM6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)