UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W4wKJECusMmuTuAtVSv0MaIkn9S13HgBbviB9L+yCW8='
WHERE
key_id = 'c2057e69c00b923fa2b49abfbf805b6c41295e8576822da6236b4099c2bbef4d'
AND (
token = 'W4wKJECusMmuTuAtVSv0MaIkn9S13HgBbviB9L+yCW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)