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