UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FcHdIsJwT7bq/hpXTEeQOe9N4cYYxo99JngmpFGGecw='
WHERE
key_id = '4949484cf7e6e990552c1446e79b21ce045b7d71701c19b14a41e1ea5c7a5ae1'
AND (
token = 'FcHdIsJwT7bq/hpXTEeQOe9N4cYYxo99JngmpFGGecw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)