SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'b2dc8cad2efe55c27ae33e7bd0f0aa04b6e614e4227d66fef53885d7824829ae' 
  AND token = 'MXhwVfJXeene5bHgxyIF8Alu41q60v7t59Suia4xlL4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00048

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}