UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7TnIY7UYqV5fgUtvLNHabXCX36cCHyprXuE+P4Jxuic=' 
WHERE 
  key_id = 'bcd5868e43d8dabf7c7a8fc589b76441a0904e7381f78d380e8f67059a9e0e1a' 
  AND (
    token = '7TnIY7UYqV5fgUtvLNHabXCX36cCHyprXuE+P4Jxuic=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041