UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3HD9PzsRY76Hx3wuC6f/yiWlO3aSreluDN/4TaVPp2o='
WHERE
key_id = '948bc94ea1fff85a86ffea4bf110fbfcec4ea4f76a988b6c21eb8dec7ed48f99'
AND (
token = '3HD9PzsRY76Hx3wuC6f/yiWlO3aSreluDN/4TaVPp2o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)