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