UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XSghq11XIY225R5Il6aEM3G/vNTEVxnb6UpJ8KM5rs8=' 
WHERE 
  key_id = '7128db6467c476aa9b9c0a237371295fa54d17a7f2de4ee85b1156e962c4ff2a' 
  AND (
    token = 'XSghq11XIY225R5Il6aEM3G/vNTEVxnb6UpJ8KM5rs8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045