UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4vzHLihMJXgbcpw2+HMp9tE2fsYf1euJ6ZdPZcteBMg='
WHERE
key_id = '8bbadb57f25eb026739d9c570a6968a698697d6268758109ccbc61c65a6e7fcf'
AND (
token = '4vzHLihMJXgbcpw2+HMp9tE2fsYf1euJ6ZdPZcteBMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)