SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2d64c70660e1bf0e437cd13e4aeae1ba827e29f6a98c19102d4cb2e193065ab5' 
  AND token = 'Iizxo7E9kvFSb3GxfvrMhc8O0mEo9+MS+en6uEgFQFM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00039

JSON explain

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