UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uQdUhofoDQZEXub+7iU9BuY12yEgAROuOEZ5UV/GQy8='
WHERE
key_id = 'fab3a3198aa23bfd679f32e3644612e6f36d67715f1368255e9347e5ac0e16e2'
AND (
token = 'uQdUhofoDQZEXub+7iU9BuY12yEgAROuOEZ5UV/GQy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)