UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L9PZWfmaGhCwH/6yilElQtstIWW7cwTdq4Y7+ZcVGGw='
WHERE
key_id = '329c78f3393504351f02163b80560079f35d5c80c2a2aca1b85af53149e166aa'
AND (
token = 'L9PZWfmaGhCwH/6yilElQtstIWW7cwTdq4Y7+ZcVGGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)