UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9XNZemvkuxrEcXxnJjjeWwsUm48igCrCfqUuma/3nak='
WHERE
key_id = '2b6a6bb2531c8ff3293e585dac44e0289b9d855b5328726e98ff681d88188cdf'
AND (
token = '9XNZemvkuxrEcXxnJjjeWwsUm48igCrCfqUuma/3nak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)