UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NpdCz4d8tx+Zs0WorngMhlfSWzFgdTx5bv8cVskSBh0='
WHERE
key_id = 'be213ac0ff5eb86474bfe10168b2c7c3ca178e8c61e287d1aea4ab066f1903db'
AND (
token = 'NpdCz4d8tx+Zs0WorngMhlfSWzFgdTx5bv8cVskSBh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)