UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UlRi4WF0m+7QN+O0hHKzLVLZ3YQVasGoO/S04gIYE0w=' 
WHERE 
  key_id = 'c7770ba4f6d070700ba185ac7ba91f49c116ffedff3b119ecb9c6754d555481b' 
  AND (
    token = 'UlRi4WF0m+7QN+O0hHKzLVLZ3YQVasGoO/S04gIYE0w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021