UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd9+MsodH1XJn5CWyIISj3kIn8VaalJDDON8TTyMREuw='
WHERE
key_id = '23b2a8f7bf9e9488cf85c40d8794117b0ef77c656f3ab72becb40135f63aba21'
AND (
token = 'd9+MsodH1XJn5CWyIISj3kIn8VaalJDDON8TTyMREuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)