UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J8mvQpeangtZEBqg1eTwF5v3RB/tQo2tvMe5zc4dnuY='
WHERE
key_id = '5808d73d68c645394494d0551ab3462083ff2fa65a64c1c49fbb07da9ed66178'
AND (
token = 'J8mvQpeangtZEBqg1eTwF5v3RB/tQo2tvMe5zc4dnuY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)