UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9zLbft0eW6IpOofNmm1KBJe7D6aHE0uZYZjou6+U0a4='
WHERE
key_id = '13bd87076d59f74e84d38a15d14a4a864879c1c0f546394bdc74b1599c7c2ece'
AND (
token = '9zLbft0eW6IpOofNmm1KBJe7D6aHE0uZYZjou6+U0a4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)