UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jc7EixyVSSndXPIzm1FC9IJ5NWv7geTzYG0LG/Grft8='
WHERE
key_id = '174afc3953707c1867b4c73f75b7ec131025b80887ffebd5c31d920233b2df8d'
AND (
token = 'Jc7EixyVSSndXPIzm1FC9IJ5NWv7geTzYG0LG/Grft8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)