UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NjvBd9sXdegLfArZFiWQea/8qQVNwdSGHXPkw5lyzmU='
WHERE
key_id = 'f0a12fa87bdd44fe4d58f422a63725ff735b7d5040b3e29970e113dfda859abf'
AND (
token = 'NjvBd9sXdegLfArZFiWQea/8qQVNwdSGHXPkw5lyzmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)