UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vZ8Ao71dnPSGu+3B73x3rlFS7YNzg8YEuAK7bnO/yWY='
WHERE
key_id = 'c3c4e62925a71670f694c697d339157e553e502671ec890b9a4cc7e81b48b97c'
AND (
token = 'vZ8Ao71dnPSGu+3B73x3rlFS7YNzg8YEuAK7bnO/yWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)