UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1PrfXfC71qBAZpHS+oyqIYc1I0F+xVR/hyBq8Wj8d+4='
WHERE
key_id = 'def98b369c22e80050f33dc41a6c65005add0b347ae4a083360053ab5efdc0a1'
AND (
token = '1PrfXfC71qBAZpHS+oyqIYc1I0F+xVR/hyBq8Wj8d+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)