UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rL1Fd90HU8L+UMtkbG67IqDbI95NJiAc+74V+ylAuag=' 
WHERE 
  key_id = '93ec3b4fc8b50e420d36a9e65e8c2af3cab3f9b4900edd518a885ff74ce3b79e' 
  AND (
    token = 'rL1Fd90HU8L+UMtkbG67IqDbI95NJiAc+74V+ylAuag=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034