UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GoOcwZJtPZaOhklRAZ0qqL30UiLY7tW8mUY4MMChIA0='
WHERE
key_id = '749b9b7dfb6768cbc53789b740adf1e261cdfa8ed99a16b5cfaed95a431807a7'
AND (
token = 'GoOcwZJtPZaOhklRAZ0qqL30UiLY7tW8mUY4MMChIA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)