UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oqLKL4gvoLAy+whKd8OHVIae/d0pf4AZYnQOMDkzmd4='
WHERE
key_id = 'f8527bf682ac6885b95b9f5724ef4acd96d3ec503cc193d1a8c7d1541111a7df'
AND (
token = 'oqLKL4gvoLAy+whKd8OHVIae/d0pf4AZYnQOMDkzmd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)