UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xYV6ZX5Ay+m8d0m1NceCfEYFwXrw7jjZXc3tJnKcXPg='
WHERE
key_id = 'ea287abb0e4b0a9d112ac62be284505210d977fe9c8a9778b4564f1c2cfc740d'
AND (
token = 'xYV6ZX5Ay+m8d0m1NceCfEYFwXrw7jjZXc3tJnKcXPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)