UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQ9oU7tkWvfuLgbLNnGJxaVCqcy8HNLGz1tNbLCrYxQ='
WHERE
key_id = 'ba84ea8b60d22f23d01d2168f854bf55d7a3ed2385735466f22c6f9a2ef05425'
AND (
token = 'XQ9oU7tkWvfuLgbLNnGJxaVCqcy8HNLGz1tNbLCrYxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)