SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'd37cf9b9a8ced408df243854061a00d4f7360bedd056b3d43f8da9694a91c27f' 
  AND token = 'afukZiVb1KvZG+w7CKXkAgYa5GXcoeeSfC5WB8M7E7w=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00031

JSON explain

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