UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1ZR7QJDwGzlqrbEiv01yT/lTH1YnAEQ+7xHfvqQfr6I=' 
WHERE 
  key_id = '4b783edf97bfe674a8f84f8c684831df6013baba62b18d75d2025f3ecc9ff7a8' 
  AND (
    token = '1ZR7QJDwGzlqrbEiv01yT/lTH1YnAEQ+7xHfvqQfr6I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036