UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u4IW0wt9EaORvJ7SvDN9rH+PMkco9IJn5hEmDV3W33o='
WHERE
key_id = 'b7f95f7ec2834ecc044ef214bd95bda8783b643003086dbc54aec98f20259bbf'
AND (
token = 'u4IW0wt9EaORvJ7SvDN9rH+PMkco9IJn5hEmDV3W33o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)